<?php
CREATE TABLE `unifiedLoginSystem`.`businessSystems` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`name` VARCHAR( 50 ) NOT NULL COMMENT '系统名称',
`url` VARCHAR( 100 ) NOT NULL COMMENT '系统路径',
`identifier` VARCHAR( 50 ) NOT NULL COMMENT '标识符',
`addTime` TIMESTAMP NOT NULL COMMENT '添加时间',
`updateTime` TIMESTAMP NOT NULL COMMENT '修改时间',
`ip` VARCHAR( 20 ) NOT NULL COMMENT '系统IP地址',
`type` INT( 11 ) NOT NULL COMMENT '预留',
PRIMARY KEY ( `id` )
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_bin COMMENT = '业务系统表';


CREATE TABLE `unifiedLoginSystem`.`serverUsers` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`userName` VARCHAR( 50 ) NOT NULL COMMENT '用户名',
`passWord` VARCHAR( 100 ) NOT NULL COMMENT '用户密码',
`phone` INT( 11 ) NOT NULL COMMENT '电话',
`mobile` INT( 11 ) NOT NULL COMMENT '手机号',
`email` VARCHAR( 100 ) NOT NULL COMMENT '电子邮箱',
`addTime` TIMESTAMP NOT NULL COMMENT '添加时间',
`updateTime` TIMESTAMP NOT NULL COMMENT '更改时间',
PRIMARY KEY ( `id` )
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_bin COMMENT = '平台用户信息表';


CREATE TABLE `unifiedLoginSystem`.`businessUsers` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`userName` VARCHAR( 50 ) NOT NULL COMMENT '系统名称',
`serverUserId` INT( 11 ) NOT NULL COMMENT '对应平台用户ID',
`businessSystemId` INT( 11 ) NOT NULL COMMENT '对应业务系统ID',
`addTime` TIMESTAMP NOT NULL COMMENT '添加时间',
`updateTime` TIMESTAMP NOT NULL COMMENT '修改时间',
PRIMARY KEY ( `id` )
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_bin COMMENT = '业务系统用户信息表';

